.. _`Replace values in Table`:

.. _`org.sysess.sympathy.data.table.tablevaluesearchreplace`:

Replace values in Table
```````````````````````

.. image:: search_replace.svg
   :width: 48


Search and replace values in Table.




Documentation
:::::::::::::

Replacements will be performed in all selected columns.

Regex
=====
If *Text replace only (using regex)* is checked, the search expression may be
a regular expression (regex). For more information about how to write regex,
see :ref:`appendix_regex`. Here, it is possible to capture part of the match
using parentheses in the search expression, see
:ref:`regex_grouping_and_capturing`.

Unless configured to use regex replacement, search, replace and default values
will be read as a values of the same type as the column it is replacing in.
For details about how to enter values for different types, see
:ref:`appendix_typed_text`.


Definition
::::::::::


Input ports
===========

    **table**  table
        Input Table


Output ports
============

    **table**  table
        Table with replaced values




Configuration
=============

    **Select columns** (columns)
        Select the columns to use perform replace on
    **Default value** (default)
        Specify default value.
    **Search** (find)
        Specify the search pattern that will be replaced.
    **Ignore case** (ignore_case)
        Ignore case when searching
    **Text replace only (using regex)** (literal)
        Perform regex replacements in string columns, i.e., columns with types text and bytes, other columns are ignored. Disable this option to replace full values, without using regex across all types of columns. Learn more about Regular expression syntax in the documentation appendix.
    **Replace** (replace)
        Specify the replacement string.
    **Use default** (use_default)
        Use default value when not found.







Examples
========

* :download:`ReplaceValuesInTable.syx </Examples/Sympathy/Data Processing/Data/ReplaceValuesInTable.syx>`




Implementation
==============

.. automodule:: node_table_value_search_replace
    :noindex:

.. class:: TableValueSearchReplace
    :noindex: